HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...